Mark List
One Hour Digital Literacy Activities

Purpose: Create a mark list and use formulas for four operations in a Spreadsheet

Lesson Notes

Make the group depending upon the class strength.
Ideally not more than 3 students per device.

Platforms Supported
  • Windows laptop/desktop.
  • Android tablet/phone.

    • Description

    Children learn to create a mark list in spreadsheet. They also learn,
    1. How to do formulas in this sheet.
    2. How to insert and delete the rows and columns.
    3. How to change cell properties in spreadsheet.

    Details

    Here are more details on how to create a mark list.

  • Click here for Windows and android notes.

    • Click here to view the explanation of marksheet video

    If the children are slow in typing, you can give them a starter ODS file with all the data typed in here.


    Fina a version of the completed ODS file with formating.here


    Teacher Instructions
    1. Explain the activity before starting the class.
    2. Show the children a print out of the final version of the mark list.
    3. Click here to view the output of the project.
    4. Use technical names whereever possible. Example sum, formula, rows, columns, cells and total.
    5. At the end of the class explain to the children what they did in this activity.